<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_ad`;");
CreateTable("CREATE TABLE `phpyun_ad` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `ad_name` varchar(100) NOT NULL,
  `did` varchar(100) NOT NULL DEFAULT '0',
  `time_start` varchar(100) NOT NULL,
  `time_end` varchar(100) NOT NULL,
  `ad_type` varchar(10) NOT NULL,
  `word_info` text NOT NULL,
  `word_url` varchar(100) NOT NULL,
  `pic_url` varchar(100) NOT NULL,
  `pic_src` varchar(100) NOT NULL,
  `pic_content` varchar(200) DEFAULT NULL,
  `pic_width` varchar(100) NOT NULL,
  `pic_height` varchar(100) NOT NULL,
  `flash_url` varchar(100) DEFAULT NULL,
  `flash_src` varchar(100) DEFAULT NULL,
  `flash_width` varchar(100) DEFAULT NULL,
  `flash_height` varchar(100) DEFAULT NULL,
  `class_id` int(20) DEFAULT NULL,
  `is_check` int(2) DEFAULT '0',
  `is_open` int(1) DEFAULT '0',
  `target` int(2) DEFAULT NULL,
  `hits` int(11) DEFAULT '0',
  `remark` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT '0',
  `lianmeng_url` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_ad` values('1','首页幻灯','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14992057095.PNG','http://www.phpyun.com','PHPYUN人才招聘系统','','',NULL,NULL,NULL,NULL,'3','1','1','2','56','','1',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('2','首页幻灯2','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14970247553.JPG','','','','',NULL,NULL,NULL,NULL,'3','1','1','2','14','','2',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('3','首页移动广告大幅','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14967040117.PNG','http://www.phpyun.com','','1200','300',NULL,NULL,NULL,NULL,'72','1','1','2','3','','0',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('4','左侧对联广告','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14956486512.JPG','http://www.phpyun.com','','','',NULL,NULL,NULL,NULL,'11','0','1','2','1','','0',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('5','右侧对联对联','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14927345292.PNG','http://www.phpyun.com','','','',NULL,NULL,NULL,NULL,'11','0','1','2','2','','0',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('6','首页移动广告小幅','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14934176012.PNG','http://www.phpyun.com','','','',NULL,NULL,NULL,NULL,'73','1','1','2','3','','0',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('7','登录页幻灯','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14943852335.JPG','http://www.phpyun.com','','1600','410',NULL,NULL,NULL,NULL,'37','1','1','1','53','','10',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('8','积分商场首页幻灯','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14947898366.JPG','','','','',NULL,NULL,NULL,NULL,'34','1','1','2','2','','0',NULL);");
ExcuteSQL("insert into `phpyun_ad` values('9','wap幻灯','0','2018-01-01','2020-01-01','pic','','','../data/upload/pimg/20170418/14994512784.PNG','http://www.phpyun.com','','','',NULL,NULL,NULL,NULL,'50','1','1','2','1','','0',NULL);");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>